# -*- coding: utf-8 -*-
from app.exts import db
import datetime

class SchoolCard(db.Model):
    __tablename__ = 'VIEW_CARD_TRJN'

    idserial = db.Column(db.String(80))
    id = db.Column(db.String(80), primary_key=True)
    userid = db.Column(db.String(80))
    username = db.Column(db.String(80))
    sex = db.Column(db.String(80))
    doorctrlcode = db.Column(db.String(80))
    doorctrlname = db.Column(db.String(80))
    doorcode = db.Column(db.String(80))
    acctime = db.Column(db.DateTime)
    # eventflag 1=回宿舍 0 =没回
    eventflag = db.Column(db.String(80))
    deptname = db.Column(db.String(80))
    pname = db.Column(db.String(80))
    cardid = db.Column(db.String(80))
    cardno = db.Column(db.String(80))
